#!/usr/bin/env python
# -*- coding: utf-8 -*-
#
#  sem título.py
#  
#  Copyright 2014 user <user@edalp1314>
#  
#  This program is free software; you can redistribute it and/or modify
#  it under the terms of the GNU General Public License as published by
#  the Free Software Foundation; either version 2 of the License, or
#  (at your option) any later version.
#  
#  This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#  
#  You should have received a copy of the GNU General Public License
#  along with this program; if not, write to the Free Software
#  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
#  MA 02110-1301, USA.
#  
#  

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from sqlalchemy.orm import relationship, backref
from sqlalchemy import Column, Integer, String, ForeignKey
from sqlalchemy.ext.declarative import declarative_base
engine = create_engine('sqlite:///treta.db')

from base import Base
from Naturalidade import Naturalidade
from Aluno import Aluno

def main():
	Session = sessionmaker(bind=engine)
	session = Session()
	print "Nomes"
	for obj in session.query(Aluno):
		print obj.nome.upper()
	print
	for obj in session.query(Aluno).filter(Aluno.nome=='Barbara Bond'):
		print "informacao sobre:"
		print "nome = ", obj.nome
		print "numero {0} e curso {1}".format(obj.numero, obj.curso.upper())
	return 0

if __name__ == '__main__':
	main()

